Global Report

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	9994
Missing cells	543
Missing cells (%)	0.3%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	6.8 MiB
Average record size in memory	718.1 B

Variable types

Numeric	7
Categorical	10
Text	3
DateTime	1

Alerts

`Country` has constant value "United States"	Constant
Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`Category` is highly overall correlated with `Sub-Category`	High correlation
`Days to Ship Actual` is highly overall correlated with `Days to Ship Scheduled` and 2 other fields	High correlation
`Days to Ship Scheduled` is highly overall correlated with `Days to Ship Actual` and 2 other fields	High correlation
`Discount` is highly overall correlated with `Profit Ratio` and 1 other fields	High correlation
`Profit Ratio` is highly overall correlated with `Discount`	High correlation
`Profit per Order` is highly overall correlated with `Discount` and 1 other fields	High correlation
`Region` is highly overall correlated with `State`	High correlation
`Sales per Customer` is highly overall correlated with `Profit per Order`	High correlation
`Ship Mode` is highly overall correlated with `Days to Ship Actual` and 1 other fields	High correlation
`Ship Status` is highly overall correlated with `Days to Ship Actual` and 1 other fields	High correlation
`State` is highly overall correlated with `Region`	High correlation
`Sub-Category` is highly overall correlated with `Category`	High correlation
`Ship Mode` has 543 (5.4%) missing values	Missing
`Days to Ship Actual` has 519 (5.2%) zeros	Zeros
`Discount` has 4798 (48.0%) zeros	Zeros

Reproduction

Analysis started	2025-07-02 21:55:14.329661
Analysis finished	2025-07-02 21:55:24.497867
Duration	10.17 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Days to Ship Actual
Real number (ℝ)

High correlation Zeros

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9581749

Minimum	0
Maximum	7
Zeros	519
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	4
Q3	5
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7475667
Coefficient of variation (CV)	0.44150822
Kurtosis	-0.28755198
Mean	3.9581749
Median Absolute Deviation (MAD)	1
Skewness	-0.42132235
Sum	39558
Variance	3.0539895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
4	2774	27.8%
5	2169	21.7%
2	1334	13.3%
6	1203	12.0%
3	1005	10.1%
7	621	6.2%
0	519	5.2%
1	369	3.7%

Value	Count	Frequency (%)
0	519	5.2%
1	369	3.7%
2	1334	13.3%
3	1005	10.1%
4	2774	27.8%
5	2169	21.7%
6	1203	12.0%
7	621	6.2%

Value	Count	Frequency (%)
7	621	6.2%
6	1203	12.0%
5	2169	21.7%
4	2774	27.8%
3	1005	10.1%
2	1334	13.3%
1	369	3.7%
0	519	5.2%

Ship Status
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	568.8 KiB

2	4909
-1	2639
1	2446

Length

Max length	2
Median length	1
Mean length	1.2640584
Min length	1

Characters and Unicode

Total characters	12633
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	-1
4th row	-1
5th row	-1

Common Values

Value	Count	Frequency (%)
2	4909	49.1%
-1	2639	26.4%
1	2446	24.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5085	50.9%
2	4909	49.1%

Most occurring characters

Value	Count	Frequency (%)
1	5085	40.3%
2	4909	38.9%
-	2639	20.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9994	79.1%
Dash Punctuation	2639	20.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5085	50.9%
2	4909	49.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2639	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	12633	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5085	40.3%
2	4909	38.9%
-	2639	20.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12633	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5085	40.3%
2	4909	38.9%
-	2639	20.9%

Days to Ship Scheduled
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	566.2 KiB

6	5968
3	1945
1	1538
0	543

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9994
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	6
5th row	6

Common Values

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Most occurring characters

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9994	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	9994	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9994	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	5968	59.7%
3	1945	19.5%
1	1538	15.4%
0	543	5.4%

Sales per Customer
Real number (ℝ)

High correlation

Distinct	5456
Distinct (%)	54.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.85799

Minimum	0.44
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.44
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.982
Maximum	22638.48
Range	22638.04
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.24512
Coefficient of variation (CV)	2.7114355
Kurtosis	305.31173
Mean	229.85799
Median Absolute Deviation (MAD)	45.405
Skewness	12.972752
Sum	2297200.8
Variance	388434.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	57	0.6%
19.44	39	0.4%
15.55	39	0.4%
25.92	36	0.4%
10.37	36	0.4%
32.4	28	0.3%
17.94	21	0.2%
6.48	21	0.2%
20.74	19	0.2%
14.94	17	0.2%
Other values (5446)	9681	96.9%

Value	Count	Frequency (%)
0.44	1	< 0.1%
0.56	1	< 0.1%
0.84	1	< 0.1%
0.85	1	< 0.1%
0.88	1	< 0.1%
0.9	1	< 0.1%
0.98	1	< 0.1%
0.99	1	< 0.1%
1.04	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.97	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.98	1	< 0.1%

Profit Ratio
Real number (ℝ)

High correlation

Distinct	288
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.037092

Minimum	-275
Maximum	50
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-275
5-th percentile	-76.7
Q1	7.5
median	27
Q3	36.3
95-th percentile	48
Maximum	50
Range	325
Interquartile range (IQR)	28.8

Descriptive statistics

Standard deviation	46.677878
Coefficient of variation (CV)	3.8778367
Kurtosis	10.172067
Mean	12.037092
Median Absolute Deviation (MAD)	17
Skewness	-2.8947013
Sum	120298.7
Variance	2178.8243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	509	5.1%
35	443	4.4%
47	353	3.5%
26	325	3.3%
49	315	3.2%
33.8	286	2.9%
29	278	2.8%
46	267	2.7%
28	260	2.6%
36.3	252	2.5%
Other values (278)	6706	67.1%

Value	Count	Frequency (%)
-275	4	< 0.1%
-270	14	0.1%
-265	5	0.1%
-260	10	0.1%
-255	13	0.1%
-250	10	0.1%
-245	1	< 0.1%
-235	2	< 0.1%
-230	1	< 0.1%
-225	2	< 0.1%

Value	Count	Frequency (%)
50	140	1.4%
49	315	3.2%
48	509	5.1%
47	353	3.5%
46	267	2.7%
45	220	2.2%
44	77	0.8%
43.3	1	< 0.1%
43	59	0.6%
42	69	0.7%

Category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	681.4 KiB

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127949
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	60.3%
Furniture	2121	21.2%
Technology	1847	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	105903	82.8%
Uppercase Letter	16020	12.5%
Space Separator	6026	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	16020	15.1%
i	14173	13.4%
p	12052	11.4%
f	12052	11.4%
u	10268	9.7%
c	7873	7.4%
l	7873	7.4%
s	6026	5.7%
r	4242	4.0%
n	3968	3.7%
Other values (5)	11356	10.7%

Uppercase Letter

Value	Count	Frequency (%)
O	6026	37.6%
S	6026	37.6%
F	2121	13.2%
T	1847	11.5%

Space Separator

Value	Count	Frequency (%)
	6026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	121923	95.3%
Common	6026	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	16020	13.1%
i	14173	11.6%
p	12052	9.9%
f	12052	9.9%
u	10268	8.4%
c	7873	6.5%
l	7873	6.5%
O	6026	4.9%
S	6026	4.9%
s	6026	4.9%
Other values (9)	23534	19.3%

Common

Value	Count	Frequency (%)
	6026	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127949	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

City
Text

Distinct	531
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	647.5 KiB

Length

Max length	17
Median length	14
Mean length	9.3306984
Min length	4

Characters and Unicode

Total characters	93251
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	0.7%

Sample

1st row	Henderson
2nd row	Henderson
3rd row	Los Angeles
4th row	Fort Lauderdale
5th row	Fort Lauderdale

Value	Count	Frequency (%)
city	994	7.0%
new	937	6.6%
york	920	6.5%
san	805	5.7%
los	747	5.2%
angeles	747	5.2%
philadelphia	537	3.8%
francisco	510	3.6%
seattle	428	3.0%
houston	377	2.6%
Other values (555)	7234	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74773	80.2%
Uppercase Letter	14236	15.3%
Space Separator	4242	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8719	11.7%
a	7591	10.2%
o	7499	10.0%
i	6229	8.3%
n	6199	8.3%
l	5986	8.0%
s	4699	6.3%
r	4468	6.0%
t	4438	5.9%
c	2393	3.2%
Other values (16)	16552	22.1%

Uppercase Letter

Value	Count	Frequency (%)
C	2085	14.6%
S	1740	12.2%
L	1295	9.1%
A	1242	8.7%
N	1134	8.0%
P	1013	7.1%
Y	940	6.6%
F	794	5.6%
D	627	4.4%
H	617	4.3%
Other values (14)	2749	19.3%

Space Separator

Value	Count	Frequency (%)
	4242	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89009	95.5%
Common	4242	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8719	9.8%
a	7591	8.5%
o	7499	8.4%
i	6229	7.0%
n	6199	7.0%
l	5986	6.7%
s	4699	5.3%
r	4468	5.0%
t	4438	5.0%
c	2393	2.7%
Other values (40)	30788	34.6%

Common

Value	Count	Frequency (%)
	4242	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	683.3 KiB

United States	9994

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	129922
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Common Values

Value	Count	Frequency (%)
United States	9994	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
united	9994	50.0%
states	9994	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	99940	76.9%
Uppercase Letter	19988	15.4%
Space Separator	9994	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	29982	30.0%
e	19988	20.0%
n	9994	10.0%
i	9994	10.0%
d	9994	10.0%
a	9994	10.0%
s	9994	10.0%

Uppercase Letter

Value	Count	Frequency (%)
U	9994	50.0%
S	9994	50.0%

Space Separator

Value	Count	Frequency (%)
	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119928	92.3%
Common	9994	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	29982	25.0%
e	19988	16.7%
n	9994	8.3%
U	9994	8.3%
i	9994	8.3%
d	9994	8.3%
S	9994	8.3%
a	9994	8.3%
s	9994	8.3%

Common

Value	Count	Frequency (%)
	9994	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129922	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Customer Name
Text

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	686.4 KiB

Length

Max length	22
Median length	18
Mean length	12.960676
Min length	7

Characters and Unicode

Total characters	129529
Distinct characters	57
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	Claire Gute
2nd row	Claire Gute
3rd row	Darrin Van Huff
4th row	Sean O'Donnell
5th row	Sean O'Donnell

Value	Count	Frequency (%)
michael	120	0.6%
frank	112	0.6%
john	107	0.5%
patrick	96	0.5%
brian	93	0.5%
stewart	93	0.5%
paul	92	0.5%
rick	91	0.5%
ken	91	0.5%
matt	86	0.4%
Other values (901)	19072	95.1%

Most occurring characters

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98856	76.3%
Uppercase Letter	20461	15.8%
Space Separator	10059	7.8%
Other Punctuation	124	0.1%
Dash Punctuation	29	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	12011	12.1%
e	11836	12.0%
n	10241	10.4%
r	9530	9.6%
i	7919	8.0%
l	6494	6.6%
o	5850	5.9%
t	5435	5.5%
s	4546	4.6%
h	3857	3.9%
Other values (18)	21137	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1830	8.9%
S	1798	8.8%
M	1749	8.5%
B	1696	8.3%
D	1325	6.5%
A	1282	6.3%
J	1134	5.5%
P	1105	5.4%
H	1005	4.9%
K	964	4.7%
Other values (16)	6573	32.1%

Space Separator

Value	Count	Frequency (%)
	10059	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	124	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119317	92.1%
Common	10212	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	12011	10.1%
e	11836	9.9%
n	10241	8.6%
r	9530	8.0%
i	7919	6.6%
l	6494	5.4%
o	5850	4.9%
t	5435	4.6%
s	4546	3.8%
h	3857	3.2%
Other values (44)	41598	34.9%

Common

Value	Count	Frequency (%)
	10059	98.5%
'	124	1.2%
-	29	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129440	99.9%
None	89	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (44)	45519	35.2%

None

Value	Count	Frequency (%)
ö	61	68.5%
ä	23	25.8%
ü	5	5.6%

Discount
Real number (ℝ)

High correlation Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.620272

Minimum	0
Maximum	80
Zeros	4798
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	20
95-th percentile	70
Maximum	80
Range	80
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	20.645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	15.620272
Median Absolute Deviation (MAD)	20
Skewness	1.6842947
Sum	156109
Variance	426.22415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	48.0%
20	3657	36.6%
70	418	4.2%
80	300	3.0%
30	227	2.3%
40	206	2.1%
60	138	1.4%
10	94	0.9%
50	66	0.7%
15	52	0.5%
Other values (2)	38	0.4%

Value	Count	Frequency (%)
0	4798	48.0%
10	94	0.9%
15	52	0.5%
20	3657	36.6%
30	227	2.3%
32	27	0.3%
40	206	2.1%
45	11	0.1%
50	66	0.7%
60	138	1.4%

Value	Count	Frequency (%)
80	300	3.0%
70	418	4.2%
60	138	1.4%
50	66	0.7%
45	11	0.1%
40	206	2.1%
32	27	0.3%
30	227	2.3%
20	3657	36.6%
15	52	0.5%

Order Date
Date

Distinct	1237
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2014-01-03 00:00:00
Maximum	2017-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Product Name
Text

Distinct	1850
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Memory size	939.5 KiB

Length

Max length	127
Median length	78
Mean length	36.914449
Min length	5

Characters and Unicode

Total characters	368923
Distinct characters	85
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	Bush Somerset Collection Bookcase
2nd row	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd row	Self-Adhesive Address Labels for Typewriters by Universal
4th row	Bretford CR4500 Series Slim Rectangular Table
5th row	Eldon Fold 'N Roll Cart System

Value	Count	Frequency (%)
xerox	865	1.5%
x	701	1.3%
with	599	1.1%
	599	1.1%
avery	557	1.0%
for	539	1.0%
binders	524	0.9%
chair	479	0.9%
black	426	0.8%
phone	374	0.7%
Other values (2798)	50371	89.9%

Most occurring characters

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	238253	64.6%
Uppercase Letter	56270	15.3%
Space Separator	46081	12.5%
Decimal Number	17981	4.9%
Other Punctuation	7152	1.9%
Dash Punctuation	2940	0.8%
Final Punctuation	67	< 0.1%
Close Punctuation	60	< 0.1%
Open Punctuation	60	< 0.1%
Math Symbol	35	< 0.1%
Other values (2)	24	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33538	14.1%
r	20791	8.7%
o	19902	8.4%
a	19064	8.0%
i	18648	7.8%
l	16365	6.9%
n	15622	6.6%
s	14683	6.2%
t	14550	6.1%
c	8924	3.7%
Other values (18)	56166	23.6%

Uppercase Letter

Value	Count	Frequency (%)
S	6281	11.2%
C	6007	10.7%
B	5530	9.8%
P	4918	8.7%
A	2948	5.2%
D	2941	5.2%
M	2870	5.1%
T	2616	4.6%
F	2510	4.5%
L	2284	4.1%
Other values (16)	17365	30.9%

Other Punctuation

Value	Count	Frequency (%)
,	3120	43.6%
/	1561	21.8%
"	1300	18.2%
.	463	6.5%
&	287	4.0%
'	257	3.6%
#	90	1.3%
%	45	0.6%
!	9	0.1%
*	9	0.1%
Other values (2)	11	0.2%

Decimal Number

Value	Count	Frequency (%)
1	3783	21.0%
0	2921	16.2%
2	2270	12.6%
4	1725	9.6%
3	1530	8.5%
5	1443	8.0%
8	1254	7.0%
9	1234	6.9%
6	941	5.2%
7	880	4.9%

Space Separator

Value	Count	Frequency (%)
	45654	99.1%
	427	0.9%

Dash Punctuation

Value	Count	Frequency (%)
-	2940	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	67	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	60	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	60	100.0%

Math Symbol

Value	Count	Frequency (%)
+	35	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	19	100.0%

Other Number

Value	Count	Frequency (%)
¾	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	294523	79.8%
Common	74400	20.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	33538	11.4%
r	20791	7.1%
o	19902	6.8%
a	19064	6.5%
i	18648	6.3%
l	16365	5.6%
n	15622	5.3%
s	14683	5.0%
t	14550	4.9%
c	8924	3.0%
Other values (44)	112436	38.2%

Common

Value	Count	Frequency (%)
	45654	61.4%
1	3783	5.1%
,	3120	4.2%
-	2940	4.0%
0	2921	3.9%
2	2270	3.1%
4	1725	2.3%
/	1561	2.1%
3	1530	2.1%
5	1443	1.9%
Other values (21)	7453	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368388	99.9%
None	449	0.1%
Punctuation	86	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (69)	149571	40.6%

None

Value	Count	Frequency (%)
	427	95.1%
é	14	3.1%
¾	5	1.1%
à	3	0.7%

Punctuation

Value	Count	Frequency (%)
”	67	77.9%
“	19	22.1%

Quantity
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	24.1%
2	2402	24.0%
5	1230	12.3%
4	1191	11.9%
1	899	9.0%
7	606	6.1%
6	572	5.7%
9	258	2.6%
8	257	2.6%
10	57	0.6%
Other values (4)	113	1.1%

Value	Count	Frequency (%)
1	899	9.0%
2	2402	24.0%
3	2409	24.1%
4	1191	11.9%
5	1230	12.3%
6	572	5.7%
7	606	6.1%
8	257	2.6%
9	258	2.6%
10	57	0.6%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.3%
12	23	0.2%
11	34	0.3%
10	57	0.6%
9	258	2.6%
8	257	2.6%
7	606	6.1%
6	572	5.7%
5	1230	12.3%

Region
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	603.9 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48565
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	32.0%
East	2848	28.5%
Central	2323	23.2%
South	1620	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38571	79.4%
Uppercase Letter	9994	20.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	9994	25.9%
s	6051	15.7%
e	5526	14.3%
a	5171	13.4%
n	2323	6.0%
r	2323	6.0%
l	2323	6.0%
o	1620	4.2%
u	1620	4.2%
h	1620	4.2%

Uppercase Letter

Value	Count	Frequency (%)
W	3203	32.0%
E	2848	28.5%
C	2323	23.2%
S	1620	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48565	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48565	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Profit per Order
Real number (ℝ)

High correlation

Distinct	5157
Distinct (%)	51.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.656785

Minimum	-6599.98
Maximum	8399.98
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-6599.98
5-th percentile	-53.031
Q1	1.73
median	8.665
Q3	29.36
95-th percentile	168.47
Maximum	8399.98
Range	14999.96
Interquartile range (IQR)	27.63

Descriptive statistics

Standard deviation	234.26014
Coefficient of variation (CV)	8.1746834
Kurtosis	397.18871
Mean	28.656785
Median Absolute Deviation (MAD)	10.78
Skewness	7.5614403
Sum	286395.91
Variance	54877.815
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.7%
6.22	50	0.5%
9.33	39	0.4%
3.63	35	0.4%
5.44	33	0.3%
15.55	26	0.3%
7.26	21	0.2%
12.44	21	0.2%
3.11	20	0.2%
6.87	16	0.2%
Other values (5147)	9668	96.7%

Value	Count	Frequency (%)
-6599.98	1	< 0.1%
-3839.99	1	< 0.1%
-3701.89	1	< 0.1%
-3399.98	1	< 0.1%
-2929.48	1	< 0.1%
-2639.99	1	< 0.1%
-2287.78	1	< 0.1%
-1862.31	1	< 0.1%
-1850.95	1	< 0.1%
-1811.08	1	< 0.1%

Value	Count	Frequency (%)
8399.98	1	< 0.1%
6719.98	1	< 0.1%
5039.99	1	< 0.1%
4946.37	1	< 0.1%
4630.48	1	< 0.1%
3919.99	1	< 0.1%
3177.47	1	< 0.1%
2799.98	1	< 0.1%
2591.96	1	< 0.1%
2504.22	1	< 0.1%

Segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	642.7 KiB

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88321
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	51.9%
Corporate	3020	30.2%
Home Office	1783	17.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74761	84.6%
Uppercase Letter	11777	13.3%
Space Separator	1783	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	13014	17.4%
e	11777	15.8%
r	11231	15.0%
m	6974	9.3%
u	5191	6.9%
s	5191	6.9%
n	5191	6.9%
f	3566	4.8%
p	3020	4.0%
a	3020	4.0%
Other values (3)	6586	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	8211	69.7%
H	1783	15.1%
O	1783	15.1%

Space Separator

Value	Count	Frequency (%)
	1783	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	86538	98.0%
Common	1783	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	13014	15.0%
e	11777	13.6%
r	11231	13.0%
C	8211	9.5%
m	6974	8.1%
u	5191	6.0%
s	5191	6.0%
n	5191	6.0%
f	3566	4.1%
p	3020	3.5%
Other values (6)	13172	15.2%

Common

Value	Count	Frequency (%)
	1783	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Ship Mode
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	543
Missing (%)	5.4%
Memory size	587.8 KiB

0.0	5968
1.0	1945
2.0	1538

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	28353
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	5968	59.7%
1.0	1945	19.5%
2.0	1538	15.4%
(Missing)	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	5968	63.1%
1.0	1945	20.6%
2.0	1538	16.3%

Most occurring characters

Value	Count	Frequency (%)
0	15419	54.4%
.	9451	33.3%
1	1945	6.9%
2	1538	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18902	66.7%
Other Punctuation	9451	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15419	81.6%
1	1945	10.3%
2	1538	8.1%

Other Punctuation

Value	Count	Frequency (%)
.	9451	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28353	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15419	54.4%
.	9451	33.3%
1	1945	6.9%
2	1538	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28353	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15419	54.4%
.	9451	33.3%
1	1945	6.9%
2	1538	5.4%

State
Categorical

High correlation

Distinct	49
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	639.3 KiB

California	2001
New York	1128
Texas	985
Pennsylvania	587
Washington	506
Other values (44)	4787

Length

Max length	20
Median length	14
Mean length	8.4871923
Min length	4

Characters and Unicode

Total characters	84821
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kentucky
2nd row	Kentucky
3rd row	California
4th row	Florida
5th row	Florida

Common Values

Value	Count	Frequency (%)
California	2001	20.0%
New York	1128	11.3%
Texas	985	9.9%
Pennsylvania	587	5.9%
Washington	506	5.1%
Illinois	492	4.9%
Ohio	469	4.7%
Florida	383	3.8%
Michigan	255	2.6%
North Carolina	249	2.5%
Other values (39)	2939	29.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2001	17.1%
new	1322	11.3%
york	1128	9.6%
texas	985	8.4%
pennsylvania	587	5.0%
washington	506	4.3%
illinois	492	4.2%
ohio	469	4.0%
florida	383	3.3%
carolina	291	2.5%
Other values (43)	3542	30.3%

Most occurring characters

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	71413	84.2%
Uppercase Letter	11696	13.8%
Space Separator	1712	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	10758	15.1%
i	9895	13.9%
n	8090	11.3%
o	7323	10.3%
r	5544	7.8%
e	5051	7.1%
l	4822	6.8%
s	4604	6.4%
f	2011	2.8%
h	1898	2.7%
Other values (14)	11417	16.0%

Uppercase Letter

Value	Count	Frequency (%)
C	2566	21.9%
N	1655	14.2%
T	1168	10.0%
Y	1128	9.6%
M	763	6.5%
I	748	6.4%
O	659	5.6%
W	621	5.3%
P	587	5.0%
F	383	3.3%
Other values (11)	1418	12.1%

Space Separator

Value	Count	Frequency (%)
	1712	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83109	98.0%
Common	1712	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10758	12.9%
i	9895	11.9%
n	8090	9.7%
o	7323	8.8%
r	5544	6.7%
e	5051	6.1%
l	4822	5.8%
s	4604	5.5%
C	2566	3.1%
f	2011	2.4%
Other values (35)	22445	27.0%

Common

Value	Count	Frequency (%)
	1712	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84821	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Sub-Category
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	626.6 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71874
Distinct characters	28
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	15.2%
Paper	1370	13.7%
Furnishings	957	9.6%
Phones	889	8.9%
Storage	846	8.5%
Art	796	8.0%
Accessories	775	7.8%
Chairs	617	6.2%
Appliances	466	4.7%
Labels	364	3.6%
Other values (7)	1391	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	61880	86.1%
Uppercase Letter	9994	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	9934	16.1%
e	8870	14.3%
r	7169	11.6%
i	5668	9.2%
n	5378	8.7%
a	4542	7.3%
o	3288	5.3%
p	3004	4.9%
h	2578	4.2%
c	2359	3.8%
Other values (8)	9090	14.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2259	22.6%
A	2037	20.4%
B	1751	17.5%
F	1174	11.7%
S	1036	10.4%
C	685	6.9%
L	364	3.6%
T	319	3.2%
E	254	2.5%
M	115	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71874	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71874	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	595.5 KiB

2017	3312
2016	2587
2015	2102
2014	1993

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	39976
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2015
5th row	2015

Common Values

Value	Count	Frequency (%)
2017	3312	33.1%
2016	2587	25.9%
2015	2102	21.0%
2014	1993	19.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	3312	33.1%
2016	2587	25.9%
2015	2102	21.0%
2014	1993	19.9%

Most occurring characters

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3312	8.3%
6	2587	6.5%
5	2102	5.3%
4	1993	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39976	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3312	8.3%
6	2587	6.5%
5	2102	5.3%
4	1993	5.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39976	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3312	8.3%
6	2587	6.5%
5	2102	5.3%
4	1993	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39976	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3312	8.3%
6	2587	6.5%
5	2102	5.3%
4	1993	5.0%

Month
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8096858

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	9
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2846544
Coefficient of variation (CV)	0.42058727
Kurtosis	-0.99132786
Mean	7.8096858
Median Absolute Deviation (MAD)	2
Skewness	-0.42969297
Sum	78050
Variance	10.788955
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	1471	14.7%
12	1408	14.1%
9	1383	13.8%
10	819	8.2%
5	735	7.4%
6	717	7.2%
7	710	7.1%
8	706	7.1%
3	696	7.0%
4	668	6.7%
Other values (2)	681	6.8%

Value	Count	Frequency (%)
1	381	3.8%
2	300	3.0%
3	696	7.0%
4	668	6.7%
5	735	7.4%
6	717	7.2%
7	710	7.1%
8	706	7.1%
9	1383	13.8%
10	819	8.2%

Value	Count	Frequency (%)
12	1408	14.1%
11	1471	14.7%
10	819	8.2%
9	1383	13.8%
8	706	7.1%
7	710	7.1%
6	717	7.2%
5	735	7.4%
4	668	6.7%
3	696	7.0%

	Category	Days to Ship Actual	Days to Ship Scheduled	Discount	Month	Profit Ratio	Profit per Order	Quantity	Region	Sales per Customer	Segment	Ship Mode	Ship Status	State	Sub-Category	Year
Category	1.000	0.000	0.000	0.377	0.014	0.271	0.056	0.000	0.000	0.072	0.000	0.000	0.000	0.019	0.999	0.000
Days to Ship Actual	0.000	1.000	0.781	-0.014	0.004	0.004	-0.007	0.016	0.041	-0.015	0.043	0.666	0.780	0.102	0.001	0.047
Days to Ship Scheduled	0.000	0.781	1.000	0.027	0.044	0.012	0.005	0.000	0.022	0.000	0.033	1.000	0.506	0.096	0.007	0.023
Discount	0.377	-0.014	0.027	1.000	-0.001	-0.645	-0.543	-0.001	0.294	-0.057	0.005	0.037	0.021	0.354	0.353	0.000
Month	0.014	0.004	0.044	-0.001	1.000	0.002	0.017	0.022	0.040	0.015	0.042	0.031	0.052	0.098	0.000	0.026
Profit Ratio	0.271	0.004	0.012	-0.645	0.002	1.000	0.500	0.000	0.203	-0.201	0.017	0.020	0.019	0.228	0.304	0.000
Profit per Order	0.056	-0.007	0.005	-0.543	0.017	0.500	1.000	0.234	0.021	0.518	0.000	0.000	0.012	0.017	0.130	0.000
Quantity	0.000	0.016	0.000	-0.001	0.022	0.000	0.234	1.000	0.000	0.327	0.012	0.000	0.009	0.004	0.000	0.013
Region	0.000	0.041	0.022	0.294	0.040	0.203	0.021	0.000	1.000	0.000	0.000	0.030	0.007	0.998	0.000	0.016
Sales per Customer	0.072	-0.015	0.000	-0.057	0.015	-0.201	0.518	0.327	0.000	1.000	0.002	0.000	0.000	0.000	0.142	0.000
Segment	0.000	0.043	0.033	0.005	0.042	0.017	0.000	0.012	0.000	0.002	1.000	0.007	0.027	0.090	0.000	0.028
Ship Mode	0.000	0.666	1.000	0.037	0.031	0.020	0.000	0.000	0.030	0.000	0.007	1.000	0.422	0.104	0.017	0.026
Ship Status	0.000	0.780	0.506	0.021	0.052	0.019	0.012	0.009	0.007	0.000	0.027	0.422	1.000	0.092	0.000	0.048
State	0.019	0.102	0.096	0.354	0.098	0.228	0.017	0.004	0.998	0.000	0.090	0.104	0.092	1.000	0.000	0.089
Sub-Category	0.999	0.001	0.007	0.353	0.000	0.304	0.130	0.000	0.000	0.142	0.000	0.017	0.000	0.000	1.000	0.000
Year	0.000	0.047	0.023	0.000	0.026	0.000	0.000	0.013	0.016	0.000	0.028	0.026	0.048	0.089	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Days to Ship Actual	Ship Status	Days to Ship Scheduled	Sales per Customer	Profit Ratio	Category	City	Country	Customer Name	Discount	Order Date	Product Name	Quantity	Region	Profit per Order	Segment	Ship Mode	State	Sub-Category	Year	Month
0	3	1	3	261.96	16.0	Furniture	Henderson	United States	Claire Gute	0.0	2016-11-08	Bush Somerset Collection Bookcase	2	South	41.91	Consumer	1.0	Kentucky	Bookcases	2016	11
1	3	1	3	731.94	30.0	Furniture	Henderson	United States	Claire Gute	0.0	2016-11-08	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	3	South	219.58	Consumer	1.0	Kentucky	Chairs	2016	11
2	4	-1	3	14.62	47.0	Office Supplies	Los Angeles	United States	Darrin Van Huff	0.0	2016-06-12	Self-Adhesive Address Labels for Typewriters by Universal	2	West	6.87	Corporate	1.0	California	Labels	2016	6
3	7	-1	6	957.58	-40.0	Furniture	Fort Lauderdale	United States	Sean O'Donnell	45.0	2015-10-11	Bretford CR4500 Series Slim Rectangular Table	5	South	-383.03	Consumer	0.0	Florida	Tables	2015	10
4	7	-1	6	22.37	11.3	Office Supplies	Fort Lauderdale	United States	Sean O'Donnell	20.0	2015-10-11	Eldon Fold 'N Roll Cart System	2	South	2.52	Consumer	0.0	Florida	Storage	2015	10
5	5	2	6	48.86	29.0	Furniture	Los Angeles	United States	Brosina Hoffman	0.0	2014-06-09	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	7	West	14.17	Consumer	0.0	California	Furnishings	2014	6
6	5	2	6	7.28	27.0	Office Supplies	Los Angeles	United States	Brosina Hoffman	0.0	2014-06-09	Newell 322	4	West	1.97	Consumer	0.0	California	Art	2014	6
7	5	2	6	907.15	10.0	Technology	Los Angeles	United States	Brosina Hoffman	20.0	2014-06-09	Mitel 5320 IP Phone VoIP phone	6	West	90.72	Consumer	0.0	California	Phones	2014	6
8	5	2	6	18.50	31.3	Office Supplies	Los Angeles	United States	Brosina Hoffman	20.0	2014-06-09	DXL Angle-View Binders with Locking Rings by Samsill	3	West	5.78	Consumer	0.0	California	Binders	2014	6
9	5	2	6	114.90	30.0	Office Supplies	Los Angeles	United States	Brosina Hoffman	0.0	2014-06-09	Belkin F5C206VTEL 6 Outlet Surge	5	West	34.47	Consumer	0.0	California	Appliances	2014	6

	Days to Ship Actual	Ship Status	Days to Ship Scheduled	Sales per Customer	Profit Ratio	Category	City	Country	Customer Name	Discount	Order Date	Product Name	Quantity	Region	Profit per Order	Segment	Ship Mode	State	Sub-Category	Year	Month
9984	6	1	6	31.50	48.0	Office Supplies	Long Beach	United States	Dianna Vittorini	0.0	2015-05-17	Self-Adhesive Removable Labels	10	East	15.12	Consumer	0.0	New York	Labels	2015	5
9985	6	1	6	55.60	29.0	Office Supplies	Long Beach	United States	Dianna Vittorini	0.0	2015-05-17	Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L	4	East	16.12	Consumer	0.0	New York	Supplies	2015	5
9986	4	2	6	36.24	42.0	Technology	Los Angeles	United States	Maris LaWare	0.0	2016-09-29	Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive	1	West	15.22	Consumer	0.0	California	Accessories	2016	9
9987	4	2	6	79.99	36.0	Technology	Athens	United States	Ruben Ausman	0.0	2017-11-17	Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology	1	South	28.80	Corporate	0.0	Georgia	Accessories	2017	11
9988	4	2	6	206.10	27.0	Technology	Athens	United States	Ruben Ausman	0.0	2017-11-17	Panasonic KX - TS880B Telephone	5	South	55.65	Corporate	0.0	Georgia	Phones	2017	11
9989	2	2	3	25.25	16.3	Furniture	Miami	United States	Tom Boeckenhauer	20.0	2014-01-21	Ultra Door Pull Handle	3	South	4.10	Consumer	1.0	Florida	Furnishings	2014	1
9990	5	2	6	91.96	17.0	Furniture	Costa Mesa	United States	Dave Brooks	0.0	2017-02-26	Tenex B1-RE Series Chair Mats for Low Pile Carpets	2	West	15.63	Consumer	0.0	California	Furnishings	2017	2
9991	5	2	6	258.58	7.5	Technology	Costa Mesa	United States	Dave Brooks	20.0	2017-02-26	Aastra 57i VoIP phone	2	West	19.39	Consumer	0.0	California	Phones	2017	2
9992	5	2	6	29.60	45.0	Office Supplies	Costa Mesa	United States	Dave Brooks	0.0	2017-02-26	It's Hot Message Books with Stickers, 2 3/4" x 5"	4	West	13.32	Consumer	0.0	California	Paper	2017	2
9993	5	-1	3	243.16	30.0	Office Supplies	Westminster	United States	Chris Cortes	0.0	2017-05-04	Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection	2	West	72.95	Consumer	1.0	California	Appliances	2017	5

Most frequently occurring

	Days to Ship Actual	Ship Status	Days to Ship Scheduled	Sales per Customer	Profit Ratio	Category	City	Country	Customer Name	Discount	Order Date	Product Name	Quantity	Region	Profit per Order	Segment	Ship Mode	State	Sub-Category	Year	Month	# duplicates
0	4	2	6	281.37	-4.3	Furniture	Columbus	United States	Laurel Beltran	30.0	2014-04-23	Global Leather Highback Executive Chair with Pneumatic Height Adjustment, Black	2	East	-12.06	Home Office	0.0	Ohio	Chairs	2014	4	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator